IF OBJECT_ID('tempdb..#TableA') IS NOT NULL DROP TABLE #TableA
GO
CREATE TABLE #TableA (A INT, B INT)
INSERT INTO #TableA
	SELECT 1 AS A, 9 AS B
	UNION SELECT 2 AS A, 9 AS B
	UNION SELECT 3 AS A, 9 AS B
	UNION SELECT 4 AS A, 9 AS B

CREATE CLUSTERED INDEX idx_1 ON #TableA(A,B)

IF OBJECT_ID('tempdb..#TableB') IS NOT NULL DROP TABLE #TableB
GO
CREATE TABLE #TableB (A INT, B INT)
INSERT INTO #TableB
SELECT 2 AS A, 9 AS B

CREATE CLUSTERED INDEX idx_2 ON #TableB(A,B)

SELECT * FROM #TableA
INTERSECT
SELECT * FROM #TableB